Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
TillID (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
OriginalTenderTypeCode (FK) | A code which uniquely identifies the type of Tender, for which the counts are being adjusted. | TY_TND_ORG | Code | varchar(20) | Tender(AS_TND) |
NewTenderTypeCode (FK) | A code which uniquely identifies the type of Tender to which the tender adjustment is being made. | TY_TND_NEW | Code | varchar(20) | Tender(AS_TND) |
AdjustmentTypeCode | A mnemonic code denoting what kind of adjustment is being made. e.g. Summary, Detailed. | TY_ADJT | Code4 | char(4) | |
Amount | The monetary value of the Tender adjustment (in the default system currency) | MO_ADJT | MoneyShortRetail | decimal(7,2) | |
ForeignCurrencyAmount | The monetary value of the Tender adjustment (in the currency of the Tender being adjusted) | MO_ADJT_FRG_CY | MoneyShortRetail | decimal(7,2) | |
OriginalCount | The original count of Tender items in the Till before the Adjustment. | UN_ORG | QuantityShortCount | decimal(3,0) | |
NewCount | The new count of Tender items in the Till after the Adjustment. | UN_NEW | QuantityShortCount | decimal(3,0) | |